Editing Spatial Index Advanced

Recompute statistics
Enable automatic statistics updating.

Allow row locks
Row locks are allowed when accessing the index. The Database Engine determines when row locks are used.

Note: SQL Azure does not support.

Allow page locks
Page locks are allowed when accessing the index. The Database Engine determines when page locks are used.

Note: SQL Azure does not support.

Create / Rebuild Option

Note: SQL Azure does not support.

Fill Factor (%)
Specify a percentage that indicates how full the Database Engine should make the leaf level of each index page during index creation or rebuild. Fill Factor must be an integer value from 1 to 100.

Pad index
The percentage of free space that is specified by fillfactor is applied to the intermediate-level pages of the index.

Sort in tempdb
Specify to store temporary sort results in tempdb.

Max. degree of parallelism
Override the max degree of parallelism configuration option for the duration of the index operation.